hostname=$1
user=$2
password=$3
db=$4
filename=$5
createsql=$6

mysql -h$hostname -u$user -p$password $db -e "$createsql"
mysqlimport -h$hostname -u$user -p$password  --local --compress $db $filename -dlr